<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_order_goods`;");
E_C("CREATE TABLE `ecs_order_goods` (
  `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_name` varchar(120) NOT NULL DEFAULT '',
  `goods_sn` varchar(60) NOT NULL DEFAULT '',
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_number` smallint(5) unsigned NOT NULL DEFAULT '1',
  `market_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `goods_attr` text NOT NULL,
  `send_number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `is_real` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `extension_code` varchar(30) NOT NULL DEFAULT '',
  `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `is_gift` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_attr_id` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`rec_id`),
  KEY `order_id` (`order_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_order_goods` values('1','1','8','飞利浦9@9v','ECS000008','0','1','478.79','385.00','颜色:黑 \n','0','1','','0','0','231');");
E_D("replace into `ecs_order_goods` values('2','2','12','摩托罗拉A810','ECS000012','0','1','1179.60','960.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('3','3','17','夏新N7','ECS000017','0','1','2760.00','2300.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('4','4','22','多普达Touch HD','ECS000022','0','1','7198.80','5999.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('5','5','9','诺基亚E66','ECS000009','0','3','2757.60','2200.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('6','5','24','P806','ECS000024','0','1','2400.00','2000.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('7','6','5','索爱原装M2卡读卡器','ECS000005','0','1','24.00','20.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('8','7','9','诺基亚E66','ECS000009','0','1','2757.60','2298.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('9','8','20','三星BC01','ECS000020','0','1','336.00','238.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('10','8','8','飞利浦9@9v','ECS000008','0','1','478.79','385.00','颜色:黑 \n','0','1','','0','0','231');");
E_D("replace into `ecs_order_goods` values('11','9','24','P806','ECS000024','0','1','2400.00','2000.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('12','10','24','P806','ECS000024','0','1','2400.00','0.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('13','11','23','诺基亚N96','ECS000023','0','1','4440.00','3800.00','附加配件: 原装电池 [+100]','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('14','12','20','三星BC01','ECS000020','0','1','336.00','238.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('15','13','12','摩托罗拉A810','ECS000012','0','1','1179.60','960.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('16','14','15','摩托罗拉A810','ECS000015','0','5','705.60','588.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('17','14','20','三星BC01','ECS000020','0','1','336.00','238.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('18','14','22','多普达Touch HD','ECS000022','0','1','7198.80','5999.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('19','14','3','诺基亚原装5800耳机','ECS000002','0','4','81.60','68.00','颜色:银色 \n','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('20','14','9','诺基亚E66','ECS000009','0','2','2757.60','2298.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('21','15','13','诺基亚5320 XpressMusic','ECS000013','0','3','1583.20','1210.00','颜色:红[10] \n','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('22','15','14','诺基亚5800XM','ECS000014','0','1','3150.00','2493.75','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('23','15','24','P806','ECS000024','0','4','2400.00','1900.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('24','15','9','诺基亚E66','ECS000009','0','1','2757.60','2183.10','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('25','15','8','飞利浦9@9v','ECS000008','0','3','478.79','379.05','颜色:黑 \n','0','1','','0','0','231');");
E_D("replace into `ecs_order_goods` values('26','16','12','摩托罗拉A810','ECS000012','0','2','1179.60','933.85','','2','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('27','16','1','KD876','ECS000000','0','1','1665.60','1318.60','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('28','17','24','P806','ECS000024','0','1','2400.00','1900.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('29','18','24','P806','ECS000024','0','5','2400.00','100.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('30','19','12','摩托罗拉A810','ECS000012','0','2','1179.60','933.85','','2','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('31','19','24','P806','ECS000024','0','2','2400.00','1850.00','颜色:灰色 \n','2','1','','0','0','167');");
E_D("replace into `ecs_order_goods` values('32','20','6','全棉色织格子格调拼接女式长袖衬衫 蓝绿格子','ECS000006','0','14','118.80','99.00','颜色:红黑格子 \n尺码:M \n','0','1','','0','0','43,46');");
E_D("replace into `ecs_order_goods` values('33','21','22','时尚撞色大翻领落肩袖雪纺衬衫 宝蓝色','ECS000022','0','1','202.79','169.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('34','21','21','Sweety甜美提花拼接雪纺上衣 裸粉色','ECS000021','0','1','70.80','59.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('35','22','21','Sweety甜美提花拼接雪纺上衣 裸粉色','ECS000021','0','1','70.80','59.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('36','23','21','Sweety甜美提花拼接雪纺上衣 裸粉色','ECS000021','0','1','70.80','59.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('37','24','21','Sweety甜美提花拼接雪纺上衣 裸粉色','ECS000021','0','1','70.80','59.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('38','25','53','沙宣（VS）垂坠质感双瓶装（洗发露750ml+护发素750ml）','ECS000053','0','1','154.79','129.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('39','26','71','佳洁士（Crest）3D炫白精研美白提亮抛光牙膏90g*2+全优7效牙刷2支','ECS000071','0','1','75.60','63.00','','1','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('40','27','74','护舒宝(whisper)超净棉丝薄卫生巾日16片优惠装*4','ECS000074','0','1','186.00','159.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('41','28','20','清扬(CLEAR)男士洗发露活力运动薄荷型400ml+100ml+100ml','ECS000020','0','1','80.28','66.90','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('42','29','19','施华蔻(Schwarzkopf)羊绒脂滋养润发乳600ml','ECS000019','0','1','110.39','0.00','','0','1','','0','0','');");

require("../../inc/footer.php");
?>